{{frmt=html}}{{lims=plcypridmaiduser}}{{name=Current Policy Usage}}{{lang=en}}{{cols=plcy=Policy%3Bmaid=Computer%user=User Name%3Bwhen=Started}}{{cach=hold:300}}
{{qstr=sql;select policyName,policyID,userComputerName,userComputerID,userName,inuseWhen
from
KSInUse,KSUsers,KSPolicies
where
{{iftg=ptyp:plcy;inusePolicyID='{{item=pdax}}'
AND }}{{iftg=ptyp:maid;inuseComputerID='{{item=pdac}}'
AND }}{{iftg=ptyp:prid;inuseProgramID='{{item=pdax}}'
AND }}{{iftg=ptyp:user;userName='{{item=pdac}}'
AND }}inuseUserID=userID
AND inusePolicyID=policyID
order by
{{iftg=sort:maid;userComputerName,
}}{{iftg=sort:user;userName,
}}{{iftg=sort:when;inuseWhen,
}}policyName}}
{{tmpl=styl;
}}
Current Policy Usage{{ifne=pnam; ({{item=pnam}})}}
{{ifeq=fram;{{tmpl=btop}}
{{tmpl=ntop}}
{{tmpl=ftop}}
{{tmpl=rtop}}
}}
Current Policy Usage{{ifne=pnam; ({{item=pnam}})}}{{ifne=icnc; }}